MySQL server has gone away
SELECT
(
SELECT COUNT(`SC_products_opt_val_variants`.`variantID`)
FROM `SC_products_opt_val_variants`
WHERE `SC_products_opt_val_variants`.`optionID` = `SC_product_options`.`optionID`
) as `count_variants`,
`SC_product_options`.*,
SC_product_options.name_ru AS _name_sort
FROM `SC_product_options`
ORDER BY `SC_product_options`.`sort_order`, _name_sort